package com.scm.erp.framework.repository;

import com.scm.erp.framework.pojo.systemConfiguration;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

@Service
@Transactional
public interface systemConfigurationRepository extends JpaRepository<systemConfiguration,Long> {

    @Query(value = "select Config.t_SImagesUrl from systemConfiguration Config where Config.t_SImagesUrl = ?1",nativeQuery = false)
    String findBySImagesUrl(String url);
    @Query(value = "select Config.t_SImagesUrl from systemConfiguration Config where Config.t_Sid = ?1",nativeQuery = false)
    String findByIdAndSImagesUrl(Long url);
}
